[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '23' >
24 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SalariedFlag | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9 | 25 | 1967-07-13 | Production | jolynn0@adventure-works.com | JoLynn Dobney | 903-555-0145 | 309738752 | JoLynn | F | 2019-06-22 | Dobney | adventure-works\jolynn0 | S | M | 23 | 2 | 903-555-0145 | | 61 | 2019-06-22 | Current | Production Supervisor - WC60 | 82 | |
| 16 | 25 | 1967-09-27 | Production | taylor0@adventure-works.com | Taylor Maxwell | 508-555-0165 | 233069302 | Taylor | M | 2019-08-05 | Maxwell | adventure-works\taylor0 | M | R | 23 | 2 | 508-555-0165 | | 59 | 2019-08-05 | Current | Production Supervisor - WC50 | 79 | |
| 18 | 25 | 1968-04-04 | Production | jo0@adventure-works.com | Jo Brown | 632-555-0129 | 446466105 | Jo | F | 2019-08-24 | Brown | adventure-works\jo0 | S | A | 23 | 2 | 632-555-0129 | | 60 | 2019-08-24 | Current | Production Supervisor - WC60 | 80 | |
| 20 | 25 | 1968-02-02 | Production | john0@adventure-works.com | John Campbell | 435-555-0113 | 494170342 | John | M | 2019-09-12 | Campbell | adventure-works\john0 | M | T | 23 | 2 | 435-555-0113 | | 60 | 2019-09-12 | Current | Production Supervisor - WC60 | 81 | |
| 27 | 25 | 1995-04-22 | Production | zheng0@adventure-works.com | Zheng Mu | 113-555-0173 | 360868122 | Zheng | M | 2020-05-30 | Mu | adventure-works\zheng0 | S | W | 23 | 2 | 113-555-0173 | | 53 | 2020-05-30 | Current | Production Supervisor - WC10 | 66 | |
| 40 | 25 | 2000-08-02 | Production | jinghao0@adventure-works.com | Jinghao Liu | 794-555-0159 | 630184120 | Jinghao | M | 2020-06-04 | Liu | adventure-works\jinghao0 | S | K | 23 | 2 | 794-555-0159 | | 58 | 2020-06-04 | Current | Production Supervisor - WC50 | 77 | |
| 46 | 23.5577 | 1980-03-14 | Production Control | ascott0@adventure-works.com | A. Scott Wright | 992-555-0194 | 685233686 | A. Scott | M | 2020-06-08 | Wright | adventure-works\ascott0 | S | 23 | 2 | 992-555-0194 | | 42 | 2020-06-08 | Current | Master Scheduler | 44 | ||
| 53 | 25 | 1999-02-21 | Production | reuben0@adventure-works.com | Reuben D'sa | 191-555-0112 | 370989364 | Reuben | M | 2020-06-11 | D'sa | adventure-works\reuben0 | M | H | 23 | 2 | 191-555-0112 | | 56 | 2020-06-11 | Current | Production Supervisor - WC40 | 72 | |
| 66 | 25 | 1995-10-07 | Production | cristian0@adventure-works.com | Cristian Petculescu | 434-555-0133 | 7201901 | Cristian | M | 2020-06-18 | Petculescu | adventure-works\cristian0 | M | K | 23 | 2 | 434-555-0133 | | 53 | 2020-06-18 | Current | Production Supervisor - WC10 | 67 | |
| 76 | 25 | 1991-10-24 | Production | kok-ho0@adventure-works.com | Kok-Ho Loh | 999-555-0155 | 778552911 | Kok-Ho | M | 2020-06-23 | Loh | adventure-works\kok-ho0 | S | T | 23 | 2 | 999-555-0155 | | 59 | 2020-06-23 | Current | Production Supervisor - WC50 | 78 | |
| 163 | 25 | 2001-11-18 | Production | shane0@adventure-works.com | Shane Kim | 810-555-0178 | 551834634 | Shane | M | 2020-08-05 | Kim | adventure-works\shane0 | S | S | 23 | 2 | 810-555-0178 | | 57 | 2020-08-05 | Current | Production Supervisor - WC45 | 75 | |
| 87 | 19.2308 | 1984-03-06 | Shipping and Receiving | pilar0@adventure-works.com | Pilar Ackerman | 577-555-0185 | 521265716 | Pilar | M | 2020-06-29 | Ackerman | adventure-works\pilar0 | S | G | 23 | 2 | 577-555-0185 | | 1 | 66 | 2020-06-29 | Current | Shipping and Receiving Supervisor | 93 |
| 177 | 25 | 2000-07-26 | Production | michael3@adventure-works.com | Michael Ray | 156-555-0199 | 578935259 | Michael | M | 2020-08-12 | Ray | adventure-works\michael3 | S | Sean | 23 | 2 | 156-555-0199 | | 55 | 2020-08-12 | Current | Production Supervisor - WC30 | 70 | |
| 89 | 25 | 1994-12-27 | Production | david4@adventure-works.com | David Hamilton | 986-555-0177 | 750905084 | David | M | 2020-06-30 | Hamilton | adventure-works\david4 | S | P | 23 | 2 | 986-555-0177 | | 56 | 2020-06-30 | Current | Production Supervisor - WC40 | 73 | |
| 186 | 25 | 1996-05-15 | Production | katie0@adventure-works.com | Katie McAskill-White | 809-555-0133 | 862951447 | Katie | F | 2020-08-17 | McAskill-White | adventure-works\katie0 | S | L | 23 | 2 | 809-555-0133 | | 41 | 2020-08-17 | Current | Production Supervisor - WC20 | 42 | |
| 111 | 25 | 1996-07-16 | Production | eric0@adventure-works.com | Eric Gubbels | 260-555-0119 | 45615666 | Eric | M | 2020-07-11 | Gubbels | adventure-works\eric0 | M | 23 | 2 | 260-555-0119 | | 40 | 2020-07-11 | Current | Production Supervisor - WC20 | 40 | ||
| 188 | 25 | 1994-12-17 | Production | jack0@adventure-works.com | Jack Richins | 552-555-0111 | 60114406 | Jack | M | 2020-08-18 | Richins | adventure-works\jack0 | S | S | 23 | 2 | 552-555-0111 | | 54 | 2020-08-18 | Current | Production Supervisor - WC30 | 68 | |
| 126 | 25 | 1988-07-12 | Production | jeff0@adventure-works.com | Jeff Hay | 350-555-0167 | 712885347 | Jeff | M | 2020-07-18 | Hay | adventure-works\jeff0 | M | V | 23 | 2 | 350-555-0167 | | 57 | 2020-07-18 | Current | Production Supervisor - WC45 | 74 | |
| 189 | 25 | 2000-03-03 | Production | andrew0@adventure-works.com | Andrew Hill | 908-555-0159 | 33237992 | Andrew | M | 2020-08-19 | Hill | adventure-works\andrew0 | S | R | 23 | 2 | 908-555-0159 | | 52 | 2020-08-19 | Current | Production Supervisor - WC10 | 65 | |
| 138 | 25 | 1993-02-12 | Production | cynthia0@adventure-works.com | Cynthia Randall | 352-555-0138 | 386315192 | Cynthia | F | 2020-07-24 | Randall | adventure-works\cynthia0 | S | S | 23 | 2 | 352-555-0138 | | 54 | 2020-07-24 | Current | Production Supervisor - WC30 | 69 | |
| 201 | 25 | 1992-01-13 | Production | lori0@adventure-works.com | Lori Kane | 289-555-0196 | 332349500 | Lori | F | 2020-08-23 | Kane | adventure-works\lori0 | S | A | 23 | 2 | 289-555-0196 | | 58 | 2020-08-23 | Current | Production Supervisor - WC45 | 76 | |
| 147 | 25 | 1988-10-01 | Production | yuhong0@adventure-works.com | Yuhong Li | 965-555-0155 | 319472946 | Yuhong | M | 2020-07-29 | Li | adventure-works\yuhong0 | M | L | 23 | 2 | 965-555-0155 | | 40 | 2020-07-29 | Current | Production Supervisor - WC20 | 41 | |
| 204 | 28.8462 | 1989-04-22 | Quality Assurance | hazem0@adventure-works.com | Hazem Abolrous | 869-555-0125 | 398223854 | Hazem | M | 2020-08-25 | Abolrous | adventure-works\hazem0 | S | E | 23 | 2 | 869-555-0125 | | 1 | 60 | 2020-08-25 | Current | Quality Assurance Manager | 80 |
| 214 | 25 | 1994-08-25 | Production | brenda0@adventure-works.com | Brenda Diaz | 142-555-0139 | 634335025 | Brenda | F | 2020-08-30 | Diaz | adventure-works\brenda0 | M | M | 23 | 2 | 142-555-0139 | | 55 | 2020-08-30 | Current | Production Supervisor - WC40 | 71 |
Generated 2025-12-25 23:15:34.961 UTC